using System;
using System.Data;
using System.Collections.Generic;
namespace eTMS.DAO{
	/********************************BEGIN ApDungChuongTrinhDaoTaoDAO****************************************/
	///<summary>
	/// <para>Author: Auto generated class by CSharp Code Generator v2.0</para>
	/// <para>Date:29/08/2010 46:08:14</para>
	/// <para>Class Name: ApDungChuongTrinhDaoTaoDAO</para>
	/// <para>Description: Class access to table ApDungChuongTrinhDaoTao in database. Class for coder code here</para>
	///</summary>

	
	public partial class ApDungChuongTrinhDaoTaoDAO{
        public DataSet SelectAllDSWithNganhHocByKhoaHoc(int KhoaHoc_ID)
        {
            IDbCommand cmd = this.CreateCommand();
            cmd.CommandText = @"SELECT        ApDungChuongTrinhDaoTao.ChuongTrinhDaoTao_ID, ApDungChuongTrinhDaoTao.ApDungChuongTrinhDaoTao_ID, ChuongTrinhDaoTao.NganhHoc_ID
                                FROM            ApDungChuongTrinhDaoTao INNER JOIN
                                    ChuongTrinhDaoTao ON ApDungChuongTrinhDaoTao.ChuongTrinhDaoTao_ID = ChuongTrinhDaoTao.ChuongTrinhDaoTao_ID WHERE ApDungChuongTrinhDaoTao.KhoaHoc_ID="+KhoaHoc_ID.ToString();
            return this.SelectDS(cmd);
        }

	}
	/*****************************************************************************************************/
	/**********************************END ApDungChuongTrinhDaoTaoDAO*****************************************/
	/*****************************************************************************************************/
}

